Silmaril's Code Generation Tool - MS SQL

Generates c# classes from MS-SQL database.Each class has it's Constructors,CRUD Methods and methods fetches data according foreign keys.

DSQLT - Dynamic SQL Templates

dsqlt.zip (2,8 MB)
DSQLT - Dynamic SQL Templates Use Stored Procedures as templates for dynamic SQL statements. Substitute parameters @0-@9 with values like objectnames or list of columnnames. Iterate over cursor-resultset instead of constant values. Write object-independent algorithms in T-SQL.

ExpressMaint

SQL Server 2008 Extended Events SSMS Addin

SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a SSMS Addin to bridge this gap.

FileSystemHelper SQL Server CLR

FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

Genesis Smart Framework

The Genesis Smart Client Framework is a application development framework that allows developers to develop modules of code that is hosted inside of the framework. The framework takes care of user security, application deployment and online data access.

Index Analysis

Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.

LittleUmph

littleumph.zip (417 kB)
It's a little library to help you to alleviate some of the mundane stuff during your development. It has some nifty stuff like a neat database wrapper, conversion utilities, string functions and vast of other mini helpers to improve the efficiency and consistency of your code.

MapViewer: Display Maps from Spatial Data Stored in SQL 2008

MapViewer.zip (210,4 MB)
A .NET 3.5 web control that you can include in your project. This control extracts data from SQL 2008 geometry columns and draws a map image on your web page. The source download includes a Sample web page and a sample SQL 2008 database. Works in IE, FF, Opera, Chrome & Safari

Microsoft SQL Server Product Samples: Database

This project contains Database samples released with Microsoft SQL Server product.

MY IMS Free CRM

myimscrm.zip (24,7 MB)
MY IMS CRM solution delivers a fast, flexible and familiar customer relationship management software for businesses looking to enhance their everyday productivity in the areas of sales, marketing, customer service and more. It's developed in ASP/VB.Net with SQL-Express 2008.

DTS Deployment and Packaging Tools

ncldts.zip (14,7 MB)
This project includes tools for extracting and deploying DTS (Not SSIS) packages to a SQL 2000/2005/2008 server. This is especially useful when deploying more than a couple of packages, or a SQL upgrade where DTS will still be used.

SQLCLR Cmd Exec Framework Example

For users of MS SQL Server, xp_cmdshell is a utility that we usually want to have disabled. However there are still cases where calling a command line is needed. This project provides an framework/example to make command line calls. It is not meant as an xp_cmdshell replacement but as a workaround.

SQLCLR File Functions

File Functions for SQL. Implemented as a SQLCLR assembly. Compatible with SQL 2008, 2008R2, and 2012. May be compatible with SQL 2005 & 2014 (untested).

SQL Server Inventory, Configuration Monitoring, and Logging Infrastructure

nclsqlinv.zip (8,3 MB)
This project is designed to allow inventorying and configuration management of SQL Servers in your environment. Including SQL Server configurations, databases, database configurations, database file configurations. And more.

MDX Parser & Builder, OLAP Browser with Writeback for HTML5+WPF+Silverlight

OLAP Tools for XMLA data source * MDX Syntax, MDX DOM, MDX Parser, MDX Generator * Pivot Table on HTML5, WPF, Silverlight * Writeback supported * Report server

SQL Bandwidth Meter Log Parser

Parses the log files created by the Hosts Tools SQL Bandwidth Meter application

SpatialViewer

A handy application for viewing spatial data for use with SQL Server 2008. Its is very difficult to visualise a Spatial shape from a set of points, this application allows you to do that very easily. This is a windows forms application that allows you to draw shapes and obtain the spatial description for them and also enter the spatial description and have the shape displayed for you. There is a built in zoom function to zoom in on small shapes. The application also utilises the spatial data types to select shapes.

SQL 2005 Service Manager

Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related services from a convenient system tray application. Please note that there is a Vista specific release as well as the standard XP/Win2003 release. There are no differences in functionality, the Vista release has just been modified to accomodate the UAC (User Account Control) feature.

SQL Live Monitor

sqlmonitor.zip (7,5 MB)
a .NET application that provides realtime performance data on the target SQL Server instance. No installation required, data displayed in realtime, and can also be logged to CSV for offline analysis. Will also capture SQL data for processing uing PAL.